home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / curstate.sql < prev    next >
Text File  |  2000-05-12  |  2KB  |  63 lines
  1. /* RCSVER $Id: curstate.sql,v 1.5 1999-08-02 14:32:17-05 randy CURRENT $ */
  2. /* *************************************************************************
  3. *        Copyright (C) 1999, Agent Systems, Inc. All Rights Reserved.
  4. *
  5. * Name:        curstate.sql
  6. * Date:        02/23/1999
  7. * memo:        Randy Wood
  8. * Description:    Create the curstate table.
  9. * Changes:
  10. ************************************************************************* */
  11. CREATE TABLE curstate
  12. (
  13.     det_seq_num            NUMBER(38)
  14.         CONSTRAINT ref1_curstate REFERENCES mstrrec(det_seq_num),
  15.     farebox_glid            NUMBER(38),
  16.         conv_date       DATE,           /* Date for this record */
  17.     update_time            DATE,
  18.     power_fail_time            DATE,
  19.       is_cashbox_access_door_open    NUMBER(1),
  20.       is_cashbox_present        NUMBER(1),
  21.       is_cashbox_latched        NUMBER(1),
  22.       previous_cashbox_id        VARCHAR2(20),
  23.       current_cashbox_id        VARCHAR2(20),
  24.       is_jam_clearance_door_open    NUMBER(1),
  25.       is_jam_clearance_alarm_active    NUMBER(1),
  26.       is_alarm_active            NUMBER(1),
  27.       last_alarm_reason         NUMBER(38),
  28.       bus_id                 NUMBER(38),        
  29.       garage_id             NUMBER(38),    
  30.       farebox_id             NUMBER(38),
  31.       route                 NUMBER(38),    
  32.       run                 NUMBER(38),
  33.       trip                 NUMBER(38),
  34.       fare_set             NUMBER(38),
  35.       is_primary_shift_open        NUMBER(1),
  36.       primary_user_id            NUMBER(38),
  37.       primary_user_password        NUMBER(38),
  38.       primary_user_security        NUMBER(38),
  39.       is_relief_shift_open        NUMBER(1),
  40.       relief_user_id            NUMBER(38),
  41.       relief_user_password        NUMBER(38),
  42.       relief_user_security        NUMBER(38),
  43.       relief_shift_seq        NUMBER(38), 
  44.       upr_total_amount        NUMBER(38),
  45.       revenue_service_seq        NUMBER(38),
  46.       probing_seq            NUMBER(38),
  47.       primary_shift_seq        NUMBER(38),
  48.       event_seq_num            NUMBER(38),    
  49.       trace_seq_num            NUMBER(38),        
  50.       rejected_coins_reset        NUMBER(38),
  51.       rejected_bills_reset        NUMBER(38),
  52.       rejected_coins_total        NUMBER(38),
  53.       rejected_bills_total        NUMBER(38),
  54.     revenue_serv_time        DATE,
  55.     reporting_flag            NUMBER(1),
  56.     probe_context_id        NUMBER(38),
  57.     op_context_id            NUMBER(38),
  58.     driver_context_id        NUMBER(38),
  59.     fare_context_id            NUMBER(38),
  60.     power_fail_count        NUMBER(38),
  61.     CONSTRAINT pk_curstate PRIMARY KEY (det_seq_num)
  62. );
  63.